How to: Add date and time to a control.
Solution:
In the Form Design view, select the 'Insert' menu and select 'Date and Time...'. Select the 'Include Date' check box, and select the desired date format. Select the 'Include Time' check box, and select the desired time format.
1) If the Database window is not active, activate the Database window.
2) Click the 'Forms' tab in the Database window.
Forms tab
3) Select the desired form from the list box. (The selected form is highlighted.)
4) Click 'Design'. (The selected form appears in the Design view, and the floating Toolbox appears.)
5) Select the 'Insert' menu and select 'Date and Time...'. (The Date and Time dialog box appears.)
Date and Time dialog box
NOTE: Both the date and the time may be selected to appear on the form together or only one may be selected to appear on the form alone.
6) To add the date, do the following:
a) Select the 'Include Date' check box.
b) Select the appropriate radio button for the desired date format.
Include Date check box
7) To add the time, do the following:
a) Select the 'Include Time' check box.
b) Select the appropriate radio button for the desired time format.
Include Time check box
NOTE: A sample of the selected formats appears at the bottom of the dialog box.
8) Click 'OK'. (The changes are saved, and the time and/or date appears as a text box in the form design view.)
NOTE 1: If the form has a header, the text box is added to that section; if no header exists, the text box is added to the detail section.
NOTE 2: The text box appears in the upper-left hand corner of the section; move the text box to the desired location.
